Introduction of SQL server
Install SQL Server And SQL Server Management Studio
Create, Rename, and Delete Database
Create, Delete and rename table in SQL server database
Add, Rename And Delete column name
Records insert, update & delete
Select statement
Select Unique and Distinct statement
Select into statement
Insert, update and delete statement
Aggregate function count, max, min, sum, avg
What are SQL Joins
Introduction to Group by Clause
Introduction to Having Clause
Introduction to Order by clause
Introduction to Where clause
AND & OR Operator
Arithmetic Operator
Between Operator
Comparison Operator
While loop
Break and continue statement
Introduction to Stored Procedures
Select Statement Inside the Stored procedure
Insert Statement Inside a Stored Procedure
Update Statement within the Stored Procedure
Input Parameters in a Stored Procedures
Output Parameters in a Stored Procedure
Return Values in a Stored Procedure
Insert Stored Procedure output into Temporary Table
Introduction to function
Introduction to SQL View
Useful System Stored Procedures
Output Parameters in a Stored Procedure: The Output Parameters return the initialize value by the stored procedure. We can see the create variable without out or output perematar this called input variable but when we create output variable then we specify the out or output keyword for the variable and initialize the output variable by what value we want to get under output variable and print the value. Now given bellow the example code:
/*CREATE PROCEDURE*/
CREATE PROCEDURE GetDataByPeraOutputPassGendar
@Gendar nvarchar(250),
@EmpCount int out
AS
BEGIN
select @EmpCount= COUNT(Id) from Salary where Gendar=@Gendar
END
/* data with out*/
Declare @EmpTotalByGender int
EXEC GetDataByPeraOutputPassGendar 'Male', @EmpTotalByGender Output
print @EmpTotalByGender
In this code we create a Stord procedure name as ‘GetDataByPeraOutputPassGendar’ and it have two variable one is input and another is output. When we initialize the output variable by our expecting value then we receive the value and print the value from the perematar using print keyword.
About Teacher
Comments
